1 using System;
2 using
System.Collections.Generic;
3 using
System.ComponentModel;
4 using
System.Data;
5 using
System.Drawing;
6 using
System.Linq;
7 using
System.Text;
8 using
System.Threading.Tasks;
9 using
System.Windows.Forms;
10 using
System.Data.SqlClient;
11
12 namespace
MilkDairyManagementSystemCSharp
13 {
14     
public partial class SearchDairyMilkRecord : Form
15     {
16         
public SearchDairyMilkRecord()
17         {
18             InitializeComponent();
19         }
20
21         
private void SearchDairyMilkRecord_Load(object sender, EventArgs e)
22         {
23             
// TODO: This line of code loads data into the 'milkdairyDataSet.dairy' table. You can move, or remove it, as needed.
24             
this.dairyTableAdapter.Fill(this.milkdairyDataSet.dairy);
25             
using (SqlConnection con1 = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\dell\Documents\Visual Studio 2015\Projects\MilkDairyManagementSystemCSharp\MilkDairyManagementSystemCSharp\milkdairy.mdf;Integrated Security=True"))
26             {
27
28                 
string str2 = "SELECT * FROM dairy";
29                 SqlCommand cmd2 =
new SqlCommand(str2, con1);
30                 SqlDataAdapter da =
new SqlDataAdapter(cmd2);
31                 DataTable dt =
new DataTable();
32                 da.Fill(dt);
33
34                 dataGridView1.DataSource =
new BindingSource(dt, null);
35             }
36         }
37     }
38 }


Gõ tìm kiếm nhanh...